| SyStudent_Proxy |
| Logical Entity Name | SyStudent_Proxy |
| Default Table Name | SyStudent_Proxy |
| Physical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| SyStudent_Proxy Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
SyStudent_ProxyID |
bigint | NO | ||
| RecordID | int | NO | ||
| OldSSN | varchar(30) | YES | ||
| NewSSN | varchar(30) | YES | ||
| OldLastName | varchar(128) | NO | ||
| NewLastName | varchar(128) | NO | ||
| OldFirstName | varchar(128) | NO | ||
| NewFirstName | varchar(128) | NO | ||
| OldMiddleName | varchar(100) | YES | ||
| NewMiddleName | varchar(100) | YES | ||
| OldAddr1 | varchar(255) | NO | ||
| NewAddr1 | varchar(255) | NO | ||
| OldCity | varchar(25) | NO | ||
| NewCity | varchar(25) | NO | ||
| OldState | char(2) | NO | ||
| NewState | char(2) | NO | ||
| OldZip | char(10) | NO | ||
| NewZip | char(10) | NO | ||
| OldSyCountryID | int | YES | ||
| NewSyCountryID | int | YES | ||
| OldSyCampusId | int | NO | ||
| NewSyCampusId | int | NO | ||
| OldPhone | char(16) | NO | ||
| NewPhone | char(16) | NO | ||
| OldWorkphone | char(16) | NO | ||
| NewWorkphone | char(16) | NO | ||
| OldOtherPhone | char(16) | YES | ||
| NewOtherPhone | char(16) | YES | ||
| OldEmail | varchar(128) | NO | ||
| NewEmail | varchar(128) | NO | ||
| OldOtherEmail | varchar(128) | YES | ||
| NewOtherEmail | varchar(128) | YES | ||
| OldLeadDate | datetime | YES | ||
| NewLeadDate | datetime | YES | ||
| OldAmRepId | int | NO | ||
| NewAmRepId | int | NO | ||
| OldAmLeadSrcId | int | NO | ||
| NewAmLeadSrcId | int | NO | ||
| OldAmLeadTypeId | int | NO | ||
| NewAmLeadTypeId | int | NO | ||
| OldAmCitizenID | int | NO | ||
| NewAmCitizenID | int | NO | ||
| OldAlienNo | char(9) | YES | ||
| NewAlienNo | char(9) | YES | ||
| OldAmMaritalID | int | NO | ||
| NewAmMaritalID | int | NO | ||
| OldDOB | datetime | YES | ||
| NewDOB | datetime | YES | ||
| OldAmSexID | int | NO | ||
| NewAmSexID | int | NO | ||
| OldAmRaceID | int | NO | ||
| NewAmRaceID | int | NO | ||
| OldAdProgramID | int | NO | ||
| NewAdProgramID | int | NO | ||
| UserID | int | NO | ||
| ModFlag | char(1) | YES | ||
| OldSyCountyID | int | YES | ||
| NewSyCountyID | int | YES | ||
| OldStuNum | varchar(30) | YES | ||
| NewStuNum | varchar(30) | YES | ||
| OLDCMSMSServiceProviderID | int | YES | ||
| NEWCMSMSServiceProviderID | int | YES | ||
| OLDSubscribeToSMS | bit | NO | ||
| NEWSubscribeToSMS | bit | NO | ||
| OLDMobileNumber | varchar(16) | YES | ||
| NEWMobileNumber | varchar(16) | YES | ||
| OldAmPrevEducID | int | YES | ||
| NewAmPrevEducID | int | YES | ||
| OldIsHispanic | char(1) | YES | ||
| NewIsHispanic | char(1) | YES | ||
| DateAdded | datetime | NO | ||
| OldAthleticID | varchar(20) | YES | ||
| NewAthleticID | varchar(20) | YES | ||
| OldVet | char(1) | YES | ||
| NewVet | char(1) | YES | ||
| OldPreferredContactType | nvarchar(20) | YES | ||
| NewPreferredContactType | nvarchar(20) | YES | ||
| OldPreferredName | nvarchar(50) | YES | ||
| NewPreferredName | nvarchar(50) | YES | ||
| OldNickName | nvarchar(50) | YES | ||
| NewNickName | nvarchar(50) | YES |
| SyStudent_Proxy Primary and Unique Keys |
| Key Name | Key Type | Keys |
| SyStudent_Proxy_SyStudent_ProxyID_U_C_IDX | PrimaryKey | SyStudent_ProxyID |
| SyStudent_Proxy Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| SyStudent_Proxy Check Constraints |
| Check Constraint Name | CheckConstraint |
| SyStudent_Proxy Storage |
| STORAGE OPTION | STORAGE VALUE |
| Filegroup | PRIMARY |
| Text Image File Group |
| SyStudent_Proxy Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.SyStudent_Proxy |
NO | |||
| Physical (Microsoft SQL Server) dbo.SyStudent_Proxy |
NO |
| SyStudent_Proxy Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | System |
| SyStudent_Proxy Data Movement Rules |
| Name | Type | Rule Text/Value |